Tabela LResourcePanel

Definicja tabeli LResourcePanel

Name

LResourcePanel

Code

LResourcePanel

Comment

Tabela definiuje powiazanie pomiedzy zasobem/grupa zasobów, a panelem.


Lista kolumn tabeli LResourcePanel

Name

Code

LResourcePanelID

LResourcePanelID

ResourceID

ResourceID

ResourceGroupID

ResourceGroupID

ApplicationWayID

ApplicationWayID

FrequencyID

FrequencyID

PanelID

PanelID

SequenceNo

SequenceNo

IsGivenToPatient

IsGivenToPatient

GivenDaysAmount

GivenDaysAmount

OrderLength

OrderLength

UnitsCount

UnitsCount

UnitID

UnitID

Comments

Comments


Kolumna LResourcePanelID tabeli LResourcePanel

Definicja kolumny LResourcePanelID tabeli LResourcePanel

Name

LResourcePanelID

Code

LResourcePanelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli LResourcePanel

Definicja kolumny ResourceID tabeli LResourcePanel

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceGroupID tabeli LResourcePanel

Definicja kolumny ResourceGroupID tabeli LResourcePanel

Name

ResourceGroupID

Code

ResourceGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ApplicationWayID tabeli LResourcePanel

Definicja kolumny ApplicationWayID tabeli LResourcePanel

Name

ApplicationWayID

Code

ApplicationWayID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FrequencyID tabeli LResourcePanel

Definicja kolumny FrequencyID tabeli LResourcePanel

Name

FrequencyID

Code

FrequencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PanelID tabeli LResourcePanel

Definicja kolumny PanelID tabeli LResourcePanel

Name

PanelID

Code

PanelID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SequenceNo tabeli LResourcePanel

Definicja kolumny SequenceNo tabeli LResourcePanel

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IsGivenToPatient tabeli LResourcePanel

Definicja kolumny IsGivenToPatient tabeli LResourcePanel

Name

IsGivenToPatient

Code

IsGivenToPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

czy lek zostal wydany pacjentowi do domu


Kolumna GivenDaysAmount tabeli LResourcePanel

Definicja kolumny GivenDaysAmount tabeli LResourcePanel

Name

GivenDaysAmount

Code

GivenDaysAmount

Data Type

NUMBER(10)

Mandatory

No

Comment

wydano pacjentowi na n-dni


Kolumna OrderLength tabeli LResourcePanel

Definicja kolumny OrderLength tabeli LResourcePanel

Name

OrderLength

Code

OrderLength

Data Type

NUMBER(10)

Mandatory

No

Comment

dlugosc zlecenia w dniach


Kolumna UnitsCount tabeli LResourcePanel

Definicja kolumny UnitsCount tabeli LResourcePanel

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,4)

Mandatory

No

Comment

dawka zlecenia leku


Kolumna UnitID tabeli LResourcePanel

Definicja kolumny UnitID tabeli LResourcePanel

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

jednostka w jakich zlecany jest lek (np. mg)


Kolumna Comments tabeli LResourcePanel

Definicja kolumny Comments tabeli LResourcePanel

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz do zlecenia leku


Lista kluczy tabeli LResourcePanel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LResourcePanel

Definicja klucza Identifier_1 tabeli LResourcePanel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment